Hi All,

I imported the excel file into the Access but I found Type Conversion Failure. All the errors are in the Date fields. I tried changing the format of date as text in the excel and then import as field type Date/Time, but still found the same error.

Please help me out in this.

Thanks,

Tarika

Hi Tarika,

Based on your description, I tested your issue in my own environment. I worked fine without any error messages as shown in the following figure. (My sample data is very simple.)

I suggest you provide the steps of import Excel data to the Access table, and tell me the Date format in the Excel file.

Then you can refer to this link and try to use Advanced button to import data:
http://stackoverflow.com/questions/30660396/type-conversion-failure-in-access-2013
Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

If possible you can create a sample of Excel file and send it to our email address:
ibsofc@microsoft.com 
Note: Please add the URL of the case in the email subject or body.

I'm glad to help and follow up your reply.

Regards,

Emi Zhang
TechNet Community Su